SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_RelAreasTematicasSP
AS
SELECT     dbo.Tb_RelAreasTematicasSP.IdSubproyecto, dbo.Tb_MacroAreasTematicas.Mnemo, dbo.tb_AreasTematicas.Descripcion
FROM         dbo.Tb_RelAreasTematicasSP INNER JOIN
                      dbo.tb_AreasTematicas ON dbo.Tb_RelAreasTematicasSP.IdAreaTematica = dbo.tb_AreasTematicas.IdAreaTematica INNER JOIN
                      dbo.Tb_MacroAreasTematicas ON dbo.tb_AreasTematicas.MacroAreaTematica = dbo.Tb_MacroAreasTematicas.IdMacroAreaTematica
GO
GRANT SELECT ON  [dbo].[vw_RelAreasTematicasSP] TO [SoloVer]
GO
